<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_takegoods_order`;");
E_C("CREATE TABLE `ecs_takegoods_order` (
  `rec_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tg_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tg_sn` varchar(20) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `goods_id` int(10) unsigned NOT NULL,
  `goods_name` varchar(255) NOT NULL,
  `country` int(10) unsigned NOT NULL DEFAULT '0',
  `province` int(10) unsigned NOT NULL DEFAULT '0',
  `city` int(10) unsigned NOT NULL DEFAULT '0',
  `district` int(10) unsigned NOT NULL DEFAULT '0',
  `address` varchar(255) NOT NULL,
  `consignee` varchar(255) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `shipping_id` varchar(50) NOT NULL,
  `shipping_sender` varchar(50) NOT NULL,
  `shipping_time` int(10) unsigned NOT NULL DEFAULT '0',
  `paisong_name` varchar(100) NOT NULL,
  `paisong_tel` varchar(50) NOT NULL,
  `order_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `order_remark` varchar(255) NOT NULL,
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rec_id`),
  KEY `vc_sn` (`tg_sn`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_takegoods_order` values('1','8','4u6f7r7u10008','1','55','68ecshop测试商品22','1','2','52','500','11111111','111111111','11111111111','222@qq.com','','','0','','','0','','1404955490');");
E_D("replace into `ecs_takegoods_order` values('2','10','1n8i2w9o10010','1','56','泉润三层补水套装 正品专柜 保湿美白护肤爽肤水 乳液 洁面乳','1','2','52','500','22222222222','222','222222222','22@qq.ert','','','0','','','0','','1408950838');");
E_D("replace into `ecs_takegoods_order` values('3','20','1y6k6x6b10014','13','38','当日发【送皮套+保2年】Huawei/华为G750-T01 荣耀3X畅玩版手机3C','1','2','52','500','A街32号','李女士','18712345678','22@qq.ert','2014123455','admin','1411203475','','','1','','1411203438');");

require("../../inc/footer.php");
?>